[dbo].[BAEProductGetByType]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEProductGetByType

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ActivityType	varchar(500)	500

SQL Script

CREATE procedure [dbo].[BAEProductGetByType] @ActivityType as varchar(500)
AS
IF @ActivityType = ''
      BEGIN
      SELECT *
      FROM Product_Type;
      END
ELSE

Begin
      SELECT *
      FROM Product_Type
      WHERE Upper(PROD_TYPE) IN (Select Element from asi_SplitString(@ActivityType, ','))
End

GO

Uses

[dbo].[Product_Type]
[dbo].[asi_SplitString]
dbo